SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[usp_GetBulletinSubClass]
    (
      @JOL_Bulletin_Class VARCHAR(50)
    )
AS 
	SELECT '--请选择--' AS BulletinSubClass UNION ALL
    SELECT  JOL_Bulletin_SubClass
    FROM    dbo.JOL_BulletinSubClass AS a
            INNER
JOIN dbo.JOL_BulletinClass AS b ON a.JOL_Bulletin_ClassType = b.JOL_Bulletin_ClassType
    WHERE   b.JOL_Bulletin_Class = @JOL_Bulletin_Class
GO
